﻿<%@ Page Title="" Language="VB" MasterPageFile="~/Prototype.master" AutoEventWireup="false" CodeFile="SearchResultsRecipies.aspx.vb" Inherits="Recipies_SearchResultsRecipies" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:DetailsView ID="DVRecipieSearch" runat="server" Height="50px" 
        Width="424px" AutoGenerateRows="False" DataKeyNames="ID" 
        DataSourceID="DSRecipieSearch">
        <Fields>
            <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
            <asp:BoundField DataField="FirstName" HeaderText="FirstName" 
                SortExpression="FirstName" />
            <asp:BoundField DataField="LastName" HeaderText="LastName" 
                SortExpression="LastName" />
            <asp:BoundField DataField="Content" HeaderText="Content" 
                SortExpression="Content" />
            <asp:BoundField DataField="Picture" HeaderText="Picture" 
                SortExpression="Picture" />
            <asp:BoundField DataField="SubmissionDate" HeaderText="SubmissionDate" 
                SortExpression="SubmissionDate" />
        </Fields>
    </asp:DetailsView>
    <asp:SqlDataSource ID="DSRecipieSearch" runat="server" 
        ConnectionString="<%$ ConnectionStrings:myFirstDatabase %>" 
        ProviderName="<%$ ConnectionStrings:myFirstDatabase.ProviderName %>" 
        SelectCommand="SELECT [ID], [FirstName], [LastName], [Content], [Picture], [Title], [SubmissionDate] FROM [QRecipies] WHERE ([ID] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Name="ID" QueryStringField="ID" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>

